
USE [ElmuebApp]
GO
DROP TABLE pvFolios
GO
CREATE TABLE [pvFolios](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[Regional] [varchar](10) NULL,
	[Sucursal] [varchar](10) NULL,
	[Caja] [varchar](10) NULL,
	[tipo_comprobante] [varchar](50) NOT NULL,
	[folio_inicial] [int] NOT NULL,
	[folio_final] [int] NOT NULL,
	[fecha] [datetime] NOT NULL,
	[anio_aprobacion] [int] NOT NULL,
	[numero_aprobacion] [int] NOT NULL,
	[status] char(1)
 CONSTRAINT [PK_Folios] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)
)
GO

insert into pvFolios (regional, sucursal, caja, tipo_comprobante, folio_inicial, folio_final, fecha, anio_aprobacion, numero_aprobacion, status)
values ('02', '05', '01', 'Factura', 1, 500, '2011/07/12 16:53:00', 2011, 1006809, 'A')
go
